<!-- saved from url=(0014)about:internet -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>MecGridSpreadSheet.mxml</title>
<link rel="stylesheet" type="text/css" href="../../SourceStyles.css"/>
</head>

<body><pre><span class="MXMLProcessing_Instruction">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;</span>
<span class="MXMLComponent_Tag">&lt;mx:Canvas</span><span class="MXMLDefault_Text"> xmlns:mx=&quot;</span><span class="MXMLString">http://www.adobe.com/2006/mxml</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">400</span><span class="MXMLDefault_Text">&quot; height=&quot;</span><span class="MXMLString">300</span><span class="MXMLDefault_Text">&quot; xmlns:MecGrid=&quot;</span><span class="MXMLString">com.mechan.MecGrid.*</span><span class="MXMLDefault_Text">&quot; creationComplete=&quot;</span><span class="ActionScriptDefault_Text">initApp</span><span class="ActionScriptBracket/Brace">()</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">&gt;</span>
<span class="MXMLSpecial_Tag">&lt;mx:Script&gt;</span>
    <span class="ActionScriptOperator">&lt;!</span><span class="ActionScriptBracket/Brace">[</span><span class="ActionScriptDefault_Text">CDATA</span><span class="ActionScriptBracket/Brace">[</span>
        <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span>.<span class="ActionScriptDefault_Text">collections</span>.<span class="ActionScriptDefault_Text">ArrayCollection</span>;
        <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">com</span>.<span class="ActionScriptDefault_Text">mechan</span>.<span class="ActionScriptDefault_Text">MecGrid</span>.<span class="ActionScriptDefault_Text">mecGridClasses</span>.<span class="ActionScriptOperator">*</span>;
        
        <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">initApp</span><span class="ActionScriptBracket/Brace">()</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span>
        <span class="ActionScriptBracket/Brace">{</span>
            <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">redraw</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">false</span>;
            <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">editable</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">true</span>;
            <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">Rows</span>.<span class="ActionScriptDefault_Text">count</span> <span class="ActionScriptOperator">=</span> 100;
            <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">addEventListener</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">MecGridEvent</span>.<span class="ActionScriptDefault_Text">BEGIN_EDIT_CELL</span>, <span class="ActionScriptDefault_Text">beginEditCellHandler</span><span class="ActionScriptBracket/Brace">)</span>;
            <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">redraw</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">true</span>;
        <span class="ActionScriptBracket/Brace">}</span>

<span class="ActionScriptComment">// DOUBLE CLICK CELL EDITING
</span>        <span class="ActionScriptReserved">private</span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">_editing_row</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">int</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptOperator">-</span>1;
        <span class="ActionScriptReserved">private</span> <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">_editing_col</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">int</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptOperator">-</span>1;
        
        <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">beginEditCellHandler</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">event</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">MecGridEvent</span><span class="ActionScriptBracket/Brace">)</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span>
        <span class="ActionScriptBracket/Brace">{</span>
            <span class="ActionScriptDefault_Text">txtFormula</span>.<span class="ActionScriptDefault_Text">text</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">m_text</span>;
            
            <span class="ActionScriptDefault_Text">_editing_row</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptOperator">-</span>1;
            <span class="ActionScriptDefault_Text">_editing_col</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptOperator">-</span>1;
            
            <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">m_text</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">String</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">get_cell</span><span class="ActionScriptBracket/Brace">(C</span><span class="ActionScriptDefault_Text">ellOp</span>.<span class="ActionScriptDefault_Text">TEXT</span>, <span class="ActionScriptDefault_Text">event</span>.<span class="ActionScriptDefault_Text">edit_rowIndex</span>, <span class="ActionScriptDefault_Text">event</span>.<span class="ActionScriptDefault_Text">edit_colIndex</span><span class="ActionScriptBracket/Brace">)</span> <span class="ActionScriptReserved">as</span> <span class="ActionScriptDefault_Text">String</span>;
            <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">m_text</span>.<span class="ActionScriptDefault_Text">charAt</span><span class="ActionScriptBracket/Brace">(</span>0<span class="ActionScriptBracket/Brace">)</span> <span class="ActionScriptOperator">==</span> <span class="ActionScriptString">&quot;=&quot;</span><span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptDefault_Text">_editing_row</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">event</span>.<span class="ActionScriptDefault_Text">edit_rowIndex</span>;
                <span class="ActionScriptDefault_Text">_editing_col</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">event</span>.<span class="ActionScriptDefault_Text">edit_colIndex</span>;
                
                <span class="ActionScriptReserved">this</span>.<span class="ActionScriptDefault_Text">txtFormula</span>.<span class="ActionScriptDefault_Text">text</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">m_text</span>;
            <span class="ActionScriptBracket/Brace">}</span>
            <span class="ActionScriptReserved">else</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">EditCell</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">event</span>, <span class="ActionScriptDefault_Text">CellOp</span>.<span class="ActionScriptDefault_Text">EDIT_TEXT</span><span class="ActionScriptBracket/Brace">)</span>;
            <span class="ActionScriptBracket/Brace">}</span>
        <span class="ActionScriptBracket/Brace">}</span>
        
<span class="ActionScriptComment">// toolbar support
</span>        <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">updateGridRangeFont</span><span class="ActionScriptBracket/Brace">()</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span>
        <span class="ActionScriptBracket/Brace">{</span>
            <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">selcells</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">ArrayCollection</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">SelectedItems</span>;
            <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">m_fontstyle</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">int</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">FontStyleEnum</span>.<span class="ActionScriptDefault_Text">NONE</span>;
            
            <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">uiFontBold</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">==</span> <span class="ActionScriptReserved">true</span><span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptDefault_Text">m_fontstyle</span> <span class="ActionScriptOperator">|=</span> <span class="ActionScriptDefault_Text">FontStyleEnum</span>.<span class="ActionScriptDefault_Text">BOLD</span>;
            <span class="ActionScriptBracket/Brace">}</span>
            
            <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">uiFontItalic</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">==</span> <span class="ActionScriptReserved">true</span><span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptDefault_Text">m_fontstyle</span> <span class="ActionScriptOperator">|=</span> <span class="ActionScriptDefault_Text">FontStyleEnum</span>.<span class="ActionScriptDefault_Text">ITALIC</span>;
            <span class="ActionScriptBracket/Brace">}</span>
            
            <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">uiFontUnderline</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">==</span> <span class="ActionScriptReserved">true</span><span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptDefault_Text">m_fontstyle</span> <span class="ActionScriptOperator">|=</span> <span class="ActionScriptDefault_Text">FontStyleEnum</span>.<span class="ActionScriptDefault_Text">UNDERLINE</span>;
            <span class="ActionScriptBracket/Brace">}</span>
            
            <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">selcells</span> <span class="ActionScriptOperator">&amp;&amp;</span> <span class="ActionScriptDefault_Text">selcells</span>.<span class="ActionScriptDefault_Text">length</span> <span class="ActionScriptOperator">&gt;</span> 0<span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">int</span>;
                
                <span class="ActionScriptReserved">for</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">=</span>0; <span class="ActionScriptDefault_Text">i</span> <span class="ActionScriptOperator">&lt;</span> <span class="ActionScriptDefault_Text">selcells</span>.<span class="ActionScriptDefault_Text">length</span>; <span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">++</span><span class="ActionScriptBracket/Brace">)</span>
                <span class="ActionScriptBracket/Brace">{</span>
                    <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">sel</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">SelectedItem</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">selcells</span><span class="ActionScriptBracket/Brace">[</span><span class="ActionScriptDefault_Text">i</span><span class="ActionScriptBracket/Brace">]</span>;
                    <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">set_cell</span><span class="ActionScriptBracket/Brace">(C</span><span class="ActionScriptDefault_Text">ellOp</span>.<span class="ActionScriptDefault_Text">FONT_STYLE</span>, <span class="ActionScriptDefault_Text">sel</span>.<span class="ActionScriptDefault_Text">rowIndex</span>, <span class="ActionScriptDefault_Text">sel</span>.<span class="ActionScriptDefault_Text">colIndex</span>, <span class="ActionScriptDefault_Text">m_fontstyle</span><span class="ActionScriptBracket/Brace">)</span>;
                <span class="ActionScriptBracket/Brace">}</span>
            <span class="ActionScriptBracket/Brace">}</span>
        <span class="ActionScriptBracket/Brace">}</span>
        
        <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">updateGridRangeAlign</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">loc</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">String</span><span class="ActionScriptBracket/Brace">)</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span>
        <span class="ActionScriptBracket/Brace">{</span>
            <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">m_align</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">int</span>;
            
            <span class="ActionScriptReserved">switch</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">loc</span><span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
            <span class="ActionScriptReserved">case</span> <span class="ActionScriptString">&quot;left&quot;</span><span class="ActionScriptOperator">:</span>
                <span class="ActionScriptDefault_Text">uiAlignMiddle</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">false</span>;
                <span class="ActionScriptDefault_Text">uiAlignRight</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">false</span>;
                <span class="ActionScriptDefault_Text">m_align</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">CellOp</span>.<span class="ActionScriptDefault_Text">TEXTALIGN_LEFT_CENTER</span>;
                <span class="ActionScriptReserved">break</span>;
            <span class="ActionScriptReserved">case</span> <span class="ActionScriptString">&quot;center&quot;</span><span class="ActionScriptOperator">:</span>
                <span class="ActionScriptDefault_Text">uiAlignLeft</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">false</span>;
                <span class="ActionScriptDefault_Text">uiAlignRight</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">false</span>;
                <span class="ActionScriptDefault_Text">m_align</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">CellOp</span>.<span class="ActionScriptDefault_Text">TEXTALIGN_CENTER_CENTER</span>;
                <span class="ActionScriptReserved">break</span>;
            <span class="ActionScriptReserved">case</span> <span class="ActionScriptString">&quot;right&quot;</span><span class="ActionScriptOperator">:</span>
                <span class="ActionScriptDefault_Text">uiAlignLeft</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">false</span>;
                <span class="ActionScriptDefault_Text">uiAlignRight</span>.<span class="ActionScriptDefault_Text">selected</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">false</span>;
                <span class="ActionScriptDefault_Text">m_align</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">CellOp</span>.<span class="ActionScriptDefault_Text">IMAGE_ALIGN_RIGHT_CENTER</span>;
                <span class="ActionScriptReserved">break</span>;
            <span class="ActionScriptBracket/Brace">}</span>
            
            <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">selcells</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">ArrayCollection</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">SelectedItems</span>;
            
            <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">selcells</span> <span class="ActionScriptOperator">&amp;&amp;</span> <span class="ActionScriptDefault_Text">selcells</span>.<span class="ActionScriptDefault_Text">length</span> <span class="ActionScriptOperator">&gt;</span> 0<span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">int</span>;
                
                <span class="ActionScriptReserved">for</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">=</span>0; <span class="ActionScriptDefault_Text">i</span> <span class="ActionScriptOperator">&lt;</span> <span class="ActionScriptDefault_Text">selcells</span>.<span class="ActionScriptDefault_Text">length</span>; <span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">++</span><span class="ActionScriptBracket/Brace">)</span>
                <span class="ActionScriptBracket/Brace">{</span>
                    <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">sel</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">SelectedItem</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">selcells</span><span class="ActionScriptBracket/Brace">[</span><span class="ActionScriptDefault_Text">i</span><span class="ActionScriptBracket/Brace">]</span>;
                    <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">set_cell</span><span class="ActionScriptBracket/Brace">(C</span><span class="ActionScriptDefault_Text">ellOp</span>.<span class="ActionScriptDefault_Text">TEXTALIGN</span>, <span class="ActionScriptDefault_Text">sel</span>.<span class="ActionScriptDefault_Text">rowIndex</span>, <span class="ActionScriptDefault_Text">sel</span>.<span class="ActionScriptDefault_Text">colIndex</span>, <span class="ActionScriptDefault_Text">m_align</span><span class="ActionScriptBracket/Brace">)</span>;
                <span class="ActionScriptBracket/Brace">}</span>
                
                <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">redraw</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">true</span>;
            <span class="ActionScriptBracket/Brace">}</span>
        <span class="ActionScriptBracket/Brace">}</span>
                
        <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">formulaKeyDownHandler</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">event</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">KeyboardEvent</span><span class="ActionScriptBracket/Brace">)</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span>
        <span class="ActionScriptBracket/Brace">{</span>
            <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptReserved">this</span>.<span class="ActionScriptDefault_Text">_editing_col</span> <span class="ActionScriptOperator">&gt;</span> <span class="ActionScriptOperator">-</span>1 <span class="ActionScriptOperator">&amp;&amp;</span> <span class="ActionScriptDefault_Text">_editing_row</span> <span class="ActionScriptOperator">&gt;</span> <span class="ActionScriptOperator">-</span>1 <span class="ActionScriptOperator">&amp;&amp;</span> <span class="ActionScriptDefault_Text">event</span>.<span class="ActionScriptDefault_Text">keyCode</span> <span class="ActionScriptOperator">==</span> <span class="ActionScriptDefault_Text">Keyboard</span>.<span class="ActionScriptDefault_Text">ENTER</span><span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">set_cell</span><span class="ActionScriptBracket/Brace">(C</span><span class="ActionScriptDefault_Text">ellOp</span>.<span class="ActionScriptDefault_Text">TEXT</span>, <span class="ActionScriptDefault_Text">_editing_row</span>, <span class="ActionScriptDefault_Text">_editing_col</span>, <span class="ActionScriptDefault_Text">txtFormula</span>.<span class="ActionScriptDefault_Text">text</span><span class="ActionScriptBracket/Brace">)</span>;
            <span class="ActionScriptBracket/Brace">}</span>
        <span class="ActionScriptBracket/Brace">}</span>
        
        <span class="ActionScriptReserved">private</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">updateFontColor</span><span class="ActionScriptBracket/Brace">()</span><span class="ActionScriptOperator">:</span><span class="ActionScriptReserved">void</span>
        <span class="ActionScriptBracket/Brace">{</span>
            <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">selcolor</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">uint</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">uiFontColorPicker</span>.<span class="ActionScriptDefault_Text">selectedIndex</span>;
            
            <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">selcells</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">ArrayCollection</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">SelectedItems</span>;
            
            <span class="ActionScriptReserved">if</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">selcells</span> <span class="ActionScriptOperator">&amp;&amp;</span> <span class="ActionScriptDefault_Text">selcells</span>.<span class="ActionScriptDefault_Text">length</span> <span class="ActionScriptOperator">&gt;</span> 0<span class="ActionScriptBracket/Brace">)</span>
            <span class="ActionScriptBracket/Brace">{</span>
                <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">int</span>;
                
                <span class="ActionScriptReserved">for</span> <span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">=</span>0; <span class="ActionScriptDefault_Text">i</span> <span class="ActionScriptOperator">&lt;</span> <span class="ActionScriptDefault_Text">selcells</span>.<span class="ActionScriptDefault_Text">length</span>; <span class="ActionScriptDefault_Text">i</span><span class="ActionScriptOperator">++</span><span class="ActionScriptBracket/Brace">)</span>
                <span class="ActionScriptBracket/Brace">{</span>
                    <span class="ActionScriptvar">var</span> <span class="ActionScriptDefault_Text">sel</span><span class="ActionScriptOperator">:</span><span class="ActionScriptDefault_Text">SelectedItem</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptDefault_Text">selcells</span><span class="ActionScriptBracket/Brace">[</span><span class="ActionScriptDefault_Text">i</span><span class="ActionScriptBracket/Brace">]</span>;
                    <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">set_cell</span><span class="ActionScriptBracket/Brace">(C</span><span class="ActionScriptDefault_Text">ellOp</span>.<span class="ActionScriptDefault_Text">STYLE_FORECOLOR</span>, <span class="ActionScriptDefault_Text">sel</span>.<span class="ActionScriptDefault_Text">rowIndex</span>, <span class="ActionScriptDefault_Text">sel</span>.<span class="ActionScriptDefault_Text">colIndex</span>, <span class="ActionScriptDefault_Text">uiFontColorPicker</span>.<span class="ActionScriptDefault_Text">selectedColor</span><span class="ActionScriptBracket/Brace">)</span>;
                <span class="ActionScriptBracket/Brace">}</span>
                
                <span class="ActionScriptDefault_Text">mgrid</span>.<span class="ActionScriptDefault_Text">redraw</span> <span class="ActionScriptOperator">=</span> <span class="ActionScriptReserved">true</span>;
            <span class="ActionScriptBracket/Brace">}</span>
        <span class="ActionScriptBracket/Brace">}</span>
<span class="ActionScriptComment">// end of toolbar support
</span>    <span class="ActionScriptBracket/Brace">]]</span><span class="ActionScriptOperator">&gt;</span>
<span class="MXMLSpecial_Tag">&lt;/mx:Script&gt;</span>
<span class="MXMLComponent_Tag">&lt;mx:Label</span><span class="MXMLDefault_Text"> x=&quot;</span><span class="MXMLString">10</span><span class="MXMLDefault_Text">&quot; y=&quot;</span><span class="MXMLString">10</span><span class="MXMLDefault_Text">&quot; text=&quot;</span><span class="MXMLString">SPREAD SHEET</span><span class="MXMLDefault_Text">&quot; styleName=&quot;</span><span class="MXMLString">demoTitle</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
<span class="MXMLComponent_Tag">&lt;mx:VBox</span><span class="MXMLDefault_Text"> right=&quot;</span><span class="MXMLString">10</span><span class="MXMLDefault_Text">&quot; left=&quot;</span><span class="MXMLString">10</span><span class="MXMLDefault_Text">&quot; top=&quot;</span><span class="MXMLString">40</span><span class="MXMLDefault_Text">&quot; bottom=&quot;</span><span class="MXMLString">10</span><span class="MXMLDefault_Text">&quot; verticalGap=&quot;</span><span class="MXMLString">3</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">&gt;</span>
    <span class="MXMLComponent_Tag">&lt;mx:HBox</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">uiToolbar</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">&quot; includeInLayout=&quot;</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">&quot; visible=&quot;</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">&quot; horizontalGap=&quot;</span><span class="MXMLString">2</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Button</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">uiFontBold</span><span class="MXMLDefault_Text">&quot; icon=&quot;</span><span class="MXMLString">@Embed(&apos;/assets/font_bold.gif&apos;)</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; height=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; toggle=&quot;</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">&quot; click=&quot;</span><span class="ActionScriptDefault_Text">updateGridRangeFont</span><span class="ActionScriptBracket/Brace">()</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Button</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">uiFontItalic</span><span class="MXMLDefault_Text">&quot; icon=&quot;</span><span class="MXMLString">@Embed(&apos;/assets/font_italic.gif&apos;)</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; height=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; toggle=&quot;</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">&quot; click=&quot;</span><span class="ActionScriptDefault_Text">updateGridRangeFont</span><span class="ActionScriptBracket/Brace">()</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Button</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">uiFontUnderline</span><span class="MXMLDefault_Text">&quot; icon=&quot;</span><span class="MXMLString">@Embed(&apos;/assets/font_underline.gif&apos;)</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; height=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; toggle=&quot;</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">&quot; click=&quot;</span><span class="ActionScriptDefault_Text">updateGridRangeFont</span><span class="ActionScriptBracket/Brace">()</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Spacer</span><span class="MXMLDefault_Text"> width=&quot;</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Button</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">uiAlignLeft</span><span class="MXMLDefault_Text">&quot; icon=&quot;</span><span class="MXMLString">@Embed(&apos;/assets/align_left.gif&apos;)</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; height=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; toggle=&quot;</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">&quot; click=&quot;</span><span class="ActionScriptDefault_Text">updateGridRangeAlign</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">&apos;left&apos;</span><span class="ActionScriptBracket/Brace">)</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Button</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">uiAlignMiddle</span><span class="MXMLDefault_Text">&quot; icon=&quot;</span><span class="MXMLString">@Embed(&apos;/assets/align_center.gif&apos;)</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; height=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; toggle=&quot;</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">&quot; click=&quot;</span><span class="ActionScriptDefault_Text">updateGridRangeAlign</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">&apos;center&apos;</span><span class="ActionScriptBracket/Brace">)</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Button</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">uiAlignRight</span><span class="MXMLDefault_Text">&quot; icon=&quot;</span><span class="MXMLString">@Embed(&apos;/assets/align_right.gif&apos;)</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; height=&quot;</span><span class="MXMLString">20</span><span class="MXMLDefault_Text">&quot; toggle=&quot;</span><span class="MXMLString">true</span><span class="MXMLDefault_Text">&quot; click=&quot;</span><span class="ActionScriptDefault_Text">updateGridRangeAlign</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptString">&apos;right&apos;</span><span class="ActionScriptBracket/Brace">)</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Spacer</span><span class="MXMLDefault_Text"> width=&quot;</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Label</span><span class="MXMLDefault_Text"> text=&quot;</span><span class="MXMLString">FontColor</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:ColorPicker</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">uiFontColorPicker</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Button</span><span class="MXMLDefault_Text"> label=&quot;</span><span class="MXMLString">apply</span><span class="MXMLDefault_Text">&quot; click=&quot;</span><span class="ActionScriptDefault_Text">updateFontColor</span><span class="ActionScriptBracket/Brace">()</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Spacer</span><span class="MXMLDefault_Text"> width=&quot;</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:Label</span><span class="MXMLDefault_Text"> text=&quot;</span><span class="MXMLString">Formula</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
        <span class="MXMLComponent_Tag">&lt;mx:TextInput</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">txtFormula</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">&quot; keyDown=&quot;</span><span class="ActionScriptDefault_Text">formulaKeyDownHandler</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">event</span><span class="ActionScriptBracket/Brace">)</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">/&gt;</span>
    <span class="MXMLComponent_Tag">&lt;/mx:HBox&gt;</span>
    <span class="MXMLComponent_Tag">&lt;MecGrid:MecGrid</span><span class="MXMLDefault_Text"> id=&quot;</span><span class="MXMLString">mgrid</span><span class="MXMLDefault_Text">&quot; width=&quot;</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">&quot; height=&quot;</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLComponent_Tag">&gt;</span>
        <span class="MXMLComponent_Tag">&lt;MecGrid:ResourceXML&gt;</span>
            <span class="MXMLSpecial_Tag">&lt;mx:XML</span><span class="MXMLDefault_Text"> xmlns=&quot;</span><span class="MXMLDefault_Text">&quot;</span><span class="MXMLSpecial_Tag">&gt;</span>
<span class="MXMLProcessing_Instruction">&lt;List&gt;
  &lt;option cols=&quot;27&quot; fixedrows=&quot;0&quot; fixedcols=&quot;0&quot; extendlastcol=&quot;F&quot; merge_option=&quot;0&quot; merge_option_fixedcolumn=&quot;0&quot; merge_option_fixedrow=&quot;0&quot; showspreadsheet=&quot;T&quot; selectionmode=&quot;12&quot; sortoption=&quot;0&quot; treeview=&quot;T&quot; treeColumn=&quot;0&quot; textalignment=&quot;10&quot; textalignment_fixed=&quot;10&quot;/&gt;
  &lt;columns&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;0&quot; autowidth=&quot;T&quot; width=&quot;61&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;1&quot; autowidth=&quot;T&quot; width=&quot;61&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;2&quot; autowidth=&quot;T&quot; width=&quot;61&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;3&quot; autowidth=&quot;T&quot; width=&quot;61&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;4&quot; autowidth=&quot;T&quot; width=&quot;61&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;5&quot; autowidth=&quot;T&quot; width=&quot;61&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;6&quot; autowidth=&quot;T&quot; width=&quot;61&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;7&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;8&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;9&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;10&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;11&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;12&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;13&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;14&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;15&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;16&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;17&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;18&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;19&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;20&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;21&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;22&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;23&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;24&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;null&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;T&quot; colindex=&quot;25&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
    &lt;column name=&quot;&quot; datafield=&quot;&quot; visible=&quot;T&quot; editable=&quot;F&quot; colindex=&quot;26&quot; autowidth=&quot;T&quot; width=&quot;0&quot; datatype=&quot;5&quot; textalign=&quot;4&quot; textalign_fixed=&quot;4&quot; formatstring=&quot;&quot; merge=&quot;F&quot; style=&quot;null&quot; enablefilter=&quot;T&quot; header=&quot;null&quot;/&gt;
  &lt;/columns&gt;
  &lt;styles&gt;
    &lt;style name=&quot;fixedrow&quot; backcolor1=&quot;15066597&quot; backcolor2=&quot;15066597&quot; backalpha1=&quot;1&quot; backalpha2=&quot;1&quot; bordercolor=&quot;6710886&quot; borderthickness=&quot;1&quot; bt_top=&quot;1&quot; bt_bottom=&quot;1&quot; bt_left=&quot;1&quot; bt_right=&quot;1&quot; fontstyle=&quot;0&quot; forecolor=&quot;0&quot; fontsize=&quot;10&quot;/&gt;
    &lt;style name=&quot;fixedcolumn&quot; backcolor1=&quot;16317653&quot; backcolor2=&quot;15066597&quot; backalpha1=&quot;1&quot; backalpha2=&quot;1&quot; bordercolor=&quot;6710886&quot; borderthickness=&quot;1&quot; bt_top=&quot;1&quot; bt_bottom=&quot;1&quot; bt_left=&quot;1&quot; bt_right=&quot;1&quot; fontstyle=&quot;0&quot; forecolor=&quot;0&quot; fontsize=&quot;10&quot;/&gt;
    &lt;style name=&quot;subtotal&quot; backcolor1=&quot;15527148&quot; backcolor2=&quot;15066597&quot; backalpha1=&quot;1&quot; backalpha2=&quot;1&quot; bordercolor=&quot;12566463&quot; borderthickness=&quot;1&quot; bt_top=&quot;1&quot; bt_bottom=&quot;1&quot; bt_left=&quot;1&quot; bt_right=&quot;1&quot; fontstyle=&quot;2&quot; forecolor=&quot;0&quot; fontsize=&quot;10&quot;/&gt;
    &lt;style name=&quot;normal&quot; backcolor1=&quot;16777215&quot; backcolor2=&quot;16777215&quot; backalpha1=&quot;1&quot; backalpha2=&quot;1&quot; bordercolor=&quot;12566463&quot; borderthickness=&quot;1&quot; bt_top=&quot;1&quot; bt_bottom=&quot;1&quot; bt_left=&quot;1&quot; bt_right=&quot;1&quot; fontstyle=&quot;0&quot; forecolor=&quot;0&quot; fontsize=&quot;10&quot;/&gt;
    &lt;style name=&quot;spreadsheet&quot; backcolor1=&quot;15527148&quot; backcolor2=&quot;15066597&quot; backalpha1=&quot;1&quot; backalpha2=&quot;1&quot; bordercolor=&quot;10066329&quot; borderthickness=&quot;1&quot; bt_top=&quot;1&quot; bt_bottom=&quot;1&quot; bt_left=&quot;1&quot; bt_right=&quot;1&quot; fontstyle=&quot;0&quot; forecolor=&quot;0&quot; fontsize=&quot;10&quot;/&gt;
    &lt;style name=&quot;filter&quot; backcolor1=&quot;16317653&quot; backcolor2=&quot;15066597&quot; backalpha1=&quot;1&quot; backalpha2=&quot;1&quot; bordercolor=&quot;12566463&quot; borderthickness=&quot;1&quot; bt_top=&quot;1&quot; bt_bottom=&quot;1&quot; bt_left=&quot;1&quot; bt_right=&quot;1&quot; fontstyle=&quot;2&quot; forecolor=&quot;0&quot; fontsize=&quot;10&quot;/&gt;
  &lt;/styles&gt;
&lt;/List&gt;</span>
            <span class="MXMLSpecial_Tag">&lt;/mx:XML&gt;</span>
        <span class="MXMLComponent_Tag">&lt;/MecGrid:ResourceXML&gt;</span>
    <span class="MXMLComponent_Tag">&lt;/MecGrid:MecGrid&gt;</span>
<span class="MXMLComponent_Tag">&lt;/mx:VBox&gt;</span>

<span class="MXMLComponent_Tag">&lt;/mx:Canvas&gt;</span></pre></body>
</html>
